echo dump 360\n\n\n
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_info_360 > /var/www/sqlfiles/files/jk_apps_info_360_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_version_360 > /var/www/sqlfiles/files/jk_apps_version_360_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_score_data_mobile_360_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_score_data_mobile_360_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_data_mobile_360_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_data_mobile_360_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_comments_detail_360 > /var/www/sqlfiles/files/jk_apps_comments_detail_360_$(date +"%Y-%m-%d").sql

echo import 360\n\n\n
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_info_360_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_version_360_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_score_data_mobile_360_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_data_mobile_360_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_comments_detail_360_$(date +"%Y-%m-%d").sql

echo dump wandoujia\n\n\n
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_info_wandoujia > /var/www/sqlfiles/files/jk_apps_info_wandoujia_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_version_wandoujia > /var/www/sqlfiles/files/jk_apps_version_wandoujia_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_score_data_mobile_wandoujia_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_score_data_mobile_wandoujia_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_data_mobile_wandoujia_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_data_mobile_wandoujia_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_comments_detail_wandoujia > /var/www/sqlfiles/files/jk_apps_comments_detail_wandoujia_$(date +"%Y-%m-%d").sql

echo import wandoujia\n\n\n
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_info_wandoujia_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_version_wandoujia_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_score_data_mobile_wandoujia_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_data_mobile_wandoujia_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_comments_detail_wandoujia_$(date +"%Y-%m-%d").sql

echo dump jifeng\n\n\n
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_info_jifeng > /var/www/sqlfiles/files/jk_apps_info_jifeng_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_version_jifeng > /var/www/sqlfiles/files/jk_apps_version_jifeng_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_score_data_mobile_jifeng_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_score_data_mobile_jifeng_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_data_mobile_jifeng_$(date +"%Y%m") > /var/www/sqlfiles/files/jk_apps_data_mobile_jifeng_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysqldump -t --tz-utc=0 -uroot -pcoolchuan2012 -w"FTime > \"$(date +'%Y-%m-%d 00:00:01')\"" catchappdataall jk_apps_comments_detail_jifeng > /var/www/sqlfiles/files/jk_apps_comments_detail_jifeng_$(date +"%Y-%m-%d").sql

echo import jifeng\n\n\n
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_info_jifeng_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_version_jifeng_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_score_data_mobile_jifeng_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_data_mobile_jifeng_$(date +"%Y_%m")_$(date +"%Y-%m-%d").sql
mysql -uroot -pcoolchuan2012 coolweb_jk < /var/www/sqlfiles/files/jk_apps_comments_detail_jifeng_$(date +"%Y-%m-%d").sql

